# a = ws_change_ms.max_row + 1
# for i in range(1, ws_mccr_today.max_row + 1):
#     for j in range(1, ws_change_ms_temp1.max_row + 1):
#         if ws_change_ms_temp1.cell(j, 1).value == ws_mccr_today.cell(i, 1).value:
#             if ws_change_ms_temp1.cell(i, 2).value != ws_mccr_today.cell(i, 4).value:
#                 for k in range(1, 4):
#                     ws_change_ms.cell(a, k).value = ws_mccr_today.cell(i, k).value
#                 ws_change_ms.cell(a, 4).value = datetime.datetime.now()
#                 ws_change_ms.cell(a, 4).number_format = 'yyyy/mm/dd'
#                 ws_change_ms.cell(a, 5).value = ws_change_ms_temp1.cell(j, 2).value
#                 ws_change_ms.cell(a, 6).value = ws_mccr_today.cell(i, 4).value
#                 if ws_change_ms.cell(a, 5).value is None:
#                     ws_change_ms.cell(a, 7).value = "期初状态判定"
#                 a += 1
#             break
#     ws_change_ms_temp1.cell(i, 1).value = ws_mccr_today.cell(i, 1).value
#     ws_change_ms_temp1.cell(i, 2).value = ws_mccr_today.cell(i, 4).value

# 状态变更识别